package io.github.junxworks.qt.modules.tushare.mapper;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import io.github.junxworks.ep.core.orm.BaseMapper;

@Mapper
public interface OtherDataMapper extends BaseMapper {

	@Delete("delete from d_stock_topten_holders where end_date=#{endDate}")
	int deleteStockTop10HoldersByEndDate(@Param("endDate") String endDate);

	@Delete("delete from d_stock_topten_floatholders where end_date=#{endDate}")
	int deleteStockTop10FloatholdersByEndDate(@Param("endDate") String endDate);

	@Delete("delete from d_stock_repurchase where ann_date=#{annDate}")
	int deleteStockRepurchaseByAnnDate(@Param("annDate") String annDate);

	@Delete("delete from d_stock_share_float where ann_date=#{annDate}")
	int deleteStockShareFloatByAnnDate(@Param("annDate") String annDate);

	@Delete("delete from d_stock_holdertrade where ann_date=#{annDate}")
	int deleteStockHoldertradeByAnnDate(@Param("annDate") String annDate);

}
